Some users will only need to perform certain functions for iMIS data. They should not be able to perform other tasks on the system. This prevents the user from viewing data that does not pertain to their reporting responsibilities.
You can create a role restricting users to specific tables, used in running reports, with SQL Server Enterprise Manager. All dbo owned tables and views except Users, System_Params, Security_Filters, Security_Groups, Security_Modes, Security_Tables are used in reporting.
For more information refer to the Microsoft SQL Server Enterprise Manager user documentation.
To add Access reports to the menu
1. Create the Access report.
2. Select Utilities> Report Specs from the to open the Report Specifications window.
3. Click Insert to enter a new report specification.
4. Enter the System and Category where you want the Access report to appear.
5. Enter a unique Title for the new report.
6. Click Parameters to open the Detail Report Parameters window.
7. Enter RunCommand in the Control Procedure field.
8. Enter the following data in the Parameters field to point to the sample report NameMailAddressLabels in the iMIS database:
(Enterprise database)
<<Command>> “c:\Program Files\Microsoft
office\Office\MsAccess.exe”
“c:\imis_ent\access\imis_ent.mdb”;Report;NameMailA
ddressLabels;Screen (or Printer)
To add one of your reports in your Access database, enter:
<<Command>> “c:\Program Files\Microsoft
office\Office\MsAccess.exe” “full-path-to-yourdatabase-
file”;Report;your-report-name;Screen (or
Printer).
Note: The << >> symbols are less-than and greater-than symbols, not chevrons.
9. Click OK on the Detail Report Parameters window.
10. Click OK on the Report Specifications window.